UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nRiDHI8EqBHL0OLiazGAtDm9PQRc6nW3QMbANjzJimE='
WHERE
key_id = 'af4eb7fa72f92df7b971dc7f78f7b0dcca7e45f1d529652e4f21a75227cf488f'
AND (
token = 'nRiDHI8EqBHL0OLiazGAtDm9PQRc6nW3QMbANjzJimE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)