UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8prXd6X3OmDxF80FGxOdvI2b3rxiwcx0j197P10y6g='
WHERE
key_id = '59e27cba5af315960fafb963aa5b89481e0c44ca0ab9111be22f25578fde5176'
AND (
token = 'k8prXd6X3OmDxF80FGxOdvI2b3rxiwcx0j197P10y6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)