UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wVcZz2YopjfHYeWtnkooGcU6vRduiAPOG4+ziIu8pDg='
WHERE
key_id = '3dce358ae73a1c56b0a25a153cbdf3e181b170e92e13266da3729188821f720b'
AND (
token = 'wVcZz2YopjfHYeWtnkooGcU6vRduiAPOG4+ziIu8pDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)