UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPLS43nv3IiMYnhXEb0pxC6h+rCjU0CzyEvrc0ECCPs='
WHERE
key_id = 'b14d445e7f32ae0b5d952f9d0ab97dfe34acae1e9203ffc60da25e3bdf9bebc9'
AND (
token = 'tPLS43nv3IiMYnhXEb0pxC6h+rCjU0CzyEvrc0ECCPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)