UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQ4XW1+dPJohkzgktLIiewg0pOywdijNutv4ftetw1I='
WHERE
key_id = '5e64e1d0c3ff9bf05ce582c0aa9af9e49225510483e50322ee7946272480be75'
AND (
token = 'xQ4XW1+dPJohkzgktLIiewg0pOywdijNutv4ftetw1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)