UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '91FevRKJhiuB/NcAM8ph4ZXQ7B1kMjlUSgh4tjQ5Y+c='
WHERE
key_id = 'ca8c8aa8953a04e36a7a0f18bfb32631f9298d586597a2f6fdff6332e155d230'
AND (
token = '91FevRKJhiuB/NcAM8ph4ZXQ7B1kMjlUSgh4tjQ5Y+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)