UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pgrNXakfCSFgFY6QSXE+0xFtjyWKHkZjq5efVvNhTU='
WHERE
key_id = '01fd8a68d0c49932103d0552557ab4d8814395acd92eec152f94a905320e71cf'
AND (
token = '9pgrNXakfCSFgFY6QSXE+0xFtjyWKHkZjq5efVvNhTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)