UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jkW5jyFbl3clMI8p+mZR8T1UJiXPUe1pHbyzccniqD8='
WHERE
key_id = 'bd245a3fb1a08b8f22e8ee74307b65ff51b5720c76d40982b8ed815c26920146'
AND (
token = 'jkW5jyFbl3clMI8p+mZR8T1UJiXPUe1pHbyzccniqD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)