UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tg52HKsnsOWsYolU3aBZlIDrD24lAQ/E5jHTY3Q4Q7I='
WHERE
key_id = '6db27730b94bce4ba0254a7cf967e09260356cd4d974918619a7432df269b990'
AND (
token = 'Tg52HKsnsOWsYolU3aBZlIDrD24lAQ/E5jHTY3Q4Q7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)