UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pq8m102aeFExH+UnWyCoW9k1x7RmWJEkm1RA0s0PQ+8='
WHERE
key_id = '94e0e9c870c54f9cb325ac574b1ee323035c0b5e9a847d00112f97ba4027e3de'
AND (
token = 'Pq8m102aeFExH+UnWyCoW9k1x7RmWJEkm1RA0s0PQ+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)