UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9RMr4LksJtC/sq16MN0K77rPhOUaX/XiDUW7/aV8lWY='
WHERE
key_id = '670d2c2f721460251e1a1261cfe2381b10598a783ac4502973a5994cf9af96a8'
AND (
token = '9RMr4LksJtC/sq16MN0K77rPhOUaX/XiDUW7/aV8lWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)