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