UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bg8AsQsURKCmLU+eXWtRQ2MhVtFFFG6tzehT+bLT6og='
WHERE
key_id = '18db57cd7e486a5018e2b6f46f278998d55790c0166f941447800cbfa992edc7'
AND (
token = 'Bg8AsQsURKCmLU+eXWtRQ2MhVtFFFG6tzehT+bLT6og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)