UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ia9cdc7LJa6s0ibNbog9DxM3d0IMXateGehBoQSesGU='
WHERE
key_id = 'dd3e29978bc27806c5003a3d9f3400dd317a7eb3f9e0f070b3a036f0c7b9b317'
AND (
token = 'Ia9cdc7LJa6s0ibNbog9DxM3d0IMXateGehBoQSesGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)