UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DcMYdWrinfkY71b2SjlPeVyv7yypIzSMaY2UaHEbusU='
WHERE
key_id = '2dd6d66c7c55b8a572e898249fb5cb2fe87e59b430f54303262e088b50ec174d'
AND (
token = 'DcMYdWrinfkY71b2SjlPeVyv7yypIzSMaY2UaHEbusU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)