UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EFd3pOuihOnINk4lSFaf9pZCSdNLZN8VZAENHOu5qa8='
WHERE
key_id = 'e442f72c950f8996c0f6128b2fd4837b0238e7f06f0df13ec74242e14c386ed4'
AND (
token = 'EFd3pOuihOnINk4lSFaf9pZCSdNLZN8VZAENHOu5qa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)