UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'es6+vQjQJe6oc40rJ979f3kpH/gVuGhptxzoI6IwyMM='
WHERE
key_id = 'a3a6cb5342613ca72f0f5926645e12702783d978c570bca23441d4010c59ef3c'
AND (
token = 'es6+vQjQJe6oc40rJ979f3kpH/gVuGhptxzoI6IwyMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)