UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BI85J683kR9ZtpTbnqFoJ45VFj/bQMvFVPwx6C31MU4='
WHERE
key_id = '11403b7b70549888255d211e8dff945d9f05a449ecf0eb1b10deee8c88a19789'
AND (
token = 'BI85J683kR9ZtpTbnqFoJ45VFj/bQMvFVPwx6C31MU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)