UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K92kQRlu9hKOS5HoRmXBPHrGRnAmlV5+WPRtBjxpoBc='
WHERE
key_id = '1e9e713eb2f0bc800283d379c537071610404cd3c2d1f92fcabe65df3ead38cd'
AND (
token = 'K92kQRlu9hKOS5HoRmXBPHrGRnAmlV5+WPRtBjxpoBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)