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