UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sJpWxY2h9safIPmbJCh+T9d1ifr/+XPyUgVS4YjqxA='
WHERE
key_id = 'b2630a1132a871247fbd46b943ed0f0edb39dac76bb04b0972e0a1d5a5cce1f6'
AND (
token = '0sJpWxY2h9safIPmbJCh+T9d1ifr/+XPyUgVS4YjqxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)