UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7XGuarMcE297fTJSf5p4Q7OMpNgRIT+4SdRdlYKYo4='
WHERE
key_id = '3621438c366c0fe384d32ebfbb050926f6012e5832564734a0b3c7b87168e970'
AND (
token = 'U7XGuarMcE297fTJSf5p4Q7OMpNgRIT+4SdRdlYKYo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)