UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9BNTzYEpRUuNxGTJ/5Obrh5wn5UI1Ong8k1si0e3hI='
WHERE
key_id = '23a12c0c77480cebed150973791baa68b3de1827e3c17db6d9fa4ea24fd2304a'
AND (
token = 'L9BNTzYEpRUuNxGTJ/5Obrh5wn5UI1Ong8k1si0e3hI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)