UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0F78xVwdpUNdonO3Pvkx+o4E6g38V6b6tF/Le4ll7+8='
WHERE
key_id = '2c5cbbf338e9d20489b74f95095259652ef47a81635e35b600f8e6a02f65e0c6'
AND (
token = '0F78xVwdpUNdonO3Pvkx+o4E6g38V6b6tF/Le4ll7+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)