UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2a7gSqmV6DJV9B9J7GnaOByk2ZyjrcuQ2YgGfhKopVc='
WHERE
key_id = '9efdf8c57c33cf1981cabda2057f8d72e21a7bb7779023e0eb2280e2cebe762b'
AND (
token = '2a7gSqmV6DJV9B9J7GnaOByk2ZyjrcuQ2YgGfhKopVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)