UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DQupI+zIFrrd6XbSWWE+4l8V1YIwzTtcmJyQGA+jWUU='
WHERE
key_id = 'e28d8b99b9e35631457ac1cfa46a09f307d8d49516011fd3f1d798a8cb51c5c2'
AND (
token = 'DQupI+zIFrrd6XbSWWE+4l8V1YIwzTtcmJyQGA+jWUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)