UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UVuV+vEE5pO/p3toYBaejgypiQcHL8YU9t6kmwmtdX4='
WHERE
key_id = 'beac979f74f5fd639bd3208974a11855b84dd62775edfe6ed0d173957e451e2a'
AND (
token = 'UVuV+vEE5pO/p3toYBaejgypiQcHL8YU9t6kmwmtdX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)