UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'by6N5t8z4inJzVWz3jOG8NOzoKmk1YT8ONhfV+A+tiI='
WHERE
key_id = '1f328632830b7aec133d0b2e7835b88f6331677b941ad2861a22706018f97d29'
AND (
token = 'by6N5t8z4inJzVWz3jOG8NOzoKmk1YT8ONhfV+A+tiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)