UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qcj40bH5b3OvATtKq7HBgCYzHUvE5DMCkRzr3Wg13w4='
WHERE
key_id = '586ef99a081e84dd36f68b1f04550bf758da74d530020eb2722c00548947491c'
AND (
token = 'Qcj40bH5b3OvATtKq7HBgCYzHUvE5DMCkRzr3Wg13w4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)