UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iKyKUzdYzgIs0+iYs5+JlUtlUG/M1lh1fNHMzG66ZlA='
WHERE
key_id = 'a3b3eb277fd8b785e317d4d9f31f51af0c0b6844f9651abaffcad0a82b1d0567'
AND (
token = 'iKyKUzdYzgIs0+iYs5+JlUtlUG/M1lh1fNHMzG66ZlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)